CREATE TABLE [dbo].[FS_Speciality]
(
[fdSpecID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdSpecName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdCollID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[fdSpecType] [int] NOT NULL CONSTRAINT [DF_FS_Speciality_fdSpecType] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[FS_Speciality] ADD CONSTRAINT [PK_FS_peciality] PRIMARY KEY CLUSTERED  ([fdSpecID]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'1:本科生 2 研究生', 'SCHEMA', N'dbo', 'TABLE', N'FS_Speciality', 'COLUMN', N'fdSpecType'
GO
